package com.example.qxfw.common.mapper;
import com.example.qxfw.common.entity.ny.CropDistIndex;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/************************************
 *
 * @author : HuangDeYin Jolly
 * @since : JDK 11
 * @Date : 2023/7/5  星期三   9:32
 * @description : 此类用来
 ***************************************/
@Mapper
public interface CropDistIndexMapperXml extends BaseMapper {

    List<CropDistIndex> selectOrderByCropName();

    List<CropDistIndex> getCropDistIndex();

    List<CropDistIndex> selectByCropNameAndDisdesesName(@Param("cropName") String cropName, @Param("DiseasesName") String DiseasesName);

    List<CropDistIndex> selectByStartTimeAndEndTime(@Param("startTime") String startTime, @Param("endTime") String endTime);

    List<CropDistIndex> selectByCropNameAndDisdesesNameNoOrder(@Param("cropName") String cropName, @Param("DiseasesName") String DiseasesName);

    Integer insertCropDistIndex(@Param("cropDistIndex") CropDistIndex cropDistIndex);

    Integer deleteByCropNameAndDisdesesName(@Param("cropName") String cropName, @Param("diseasesName") String diseasesName);

    Integer updateByCropNameAndDisdesesName(@Param("cropDistIndex") CropDistIndex cropDistIndex);

    Integer clearCropDistIndex();

    List<CropDistIndex> selectAll();

    List<CropDistIndex> queryByCropNameColumn(@Param("cropName") String cropName, @Param("columnName") String columnName);

}